Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

gsm_filter_data table — gsmfd

This table defines the filters that apply to a filter set. The table is meant to exclude all specified data except the data that is specifically included back in. For example, exclude all objects in all Repository modules, except for objects where the template flag is true or the object type is a toolbar.

By default, the include_data flag is set to NO specifying that criteria must be excluded from the result set. If the include_data flag is set to YES, it is treated as an override condition to re-include specific data. This works by building up a bracketed WHERE clause for all the exclusions using the AND operator. It then adds an OR operator for any data that must be re-included outside the bracket to override for specific data. Use the include_data flag sparingly to avoid performance problems.

To specify a certain record, the owning_reference field points at the object ID for that table. For example, if the owning_entity_mnemonic is GSCPM for gsc_product_module, then the owning_reference points to a specific product module, product_module_obj. You can also specify a more generic expression by supplying a fieldname such as object_filename, an operator such as BEGINS, and a value such as standardtoolbar. You cannot specify a generic expression and a specific record. One or the other must be specified in a single filter data record.

This table provides significant flexibility in the specification of what data to filter. For example, it is possible to specify a list of product modules to exclude, but to re-include specific objects from some of the excluded product modules.

Table 4–21 lists the table’s FLA, fields, and foreign keys.

Table 4–21: gsm_filter_data table information

Table FLA	Fields (data type)	Foreign keys
gsmfd	filter_data_obj (Decimal) filter_set_obj (Decimal) owning_entity_mnemonic (Character) owning_reference (Character) expression_field_name (Character) expression_operator (Character) expression_value (Character) include_data (Logical)	filter_set_obj

Table 4–22 gives details of the table’s indexes.

Table 4–22: gsm_filter_data index information 

Index name	Elements	Type
XPKgsm_filter_data	filter_data_obj	Primary Unique
XIE1gsm_filter_data	filter_set_obj	Nonunique
XIE2gsm_filter_data	owning_entity_mnemonic	Nonunique
XIE3gsm_filter_data	owning_reference	Nonunique
XIE4gsm_filter_data	expression_field_name	Nonunique